UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a6Ps9DsULhHGpMJ6lKapMSHJ0gizSL8aIgUZb9N23hU='
WHERE
key_id = '4b2b10a2a8af14ea52e84bf3369c7d3f7c16a67884a12e6771fdc01f65adf069'
AND (
token = 'a6Ps9DsULhHGpMJ6lKapMSHJ0gizSL8aIgUZb9N23hU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)