UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e1BMTimL3gk3yTfS3cKBqWpz426pWLiaD6hyNPxPqHc='
WHERE
key_id = '8e38c12f650f6d3f5a46c8f38ef675587601217bdfc8e0d926e12b33b6f00be5'
AND (
token = 'e1BMTimL3gk3yTfS3cKBqWpz426pWLiaD6hyNPxPqHc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)