UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k8uG6zQO8Faitw66JTBmIvA+y5TQ+8TfhfFBsRiGipU='
WHERE
key_id = 'e7fb6a66552b877e188bfd590c95ca753d47418a6f19940f5c055e4f25e9b0ed'
AND (
token = 'k8uG6zQO8Faitw66JTBmIvA+y5TQ+8TfhfFBsRiGipU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)