UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D40wypde4dGLdLm2n2RnYfMOkHNDPYo+3jHvyxJDrYU='
WHERE
key_id = '7f787630a8f810328a88875b580a24bd47983d134d02679b77bfbc554b1ac319'
AND (
token = 'D40wypde4dGLdLm2n2RnYfMOkHNDPYo+3jHvyxJDrYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)