UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IfZlxpiKnGISUwIgRZiGKWkGmRW5F3nnNlSJHO/eiUU='
WHERE
key_id = '05867b4bbc88d8c7ff6ff169d2ec175713beb35d589df67efca8ce3dd8c95c5c'
AND (
token = 'IfZlxpiKnGISUwIgRZiGKWkGmRW5F3nnNlSJHO/eiUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)