UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HS3d9z5ihy0+eXYHMgeG7M/lWPncyqrUlaYLjS3fb+M='
WHERE
key_id = 'e8db43f4443341483a8ba979d6fdf97bfd5ba98af2ebb0d244dbdaabf6bb6517'
AND (
token = 'HS3d9z5ihy0+eXYHMgeG7M/lWPncyqrUlaYLjS3fb+M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)