UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZRHzdgKEi6Wg0+gZ1dvMEpBJSh/d+NwnXMAaFoj5CJM='
WHERE
key_id = '5e748ab8a8ed1c7cb8f2d1dbbe9e7eb83536e48fa3d74c305cb3631983ccc7d4'
AND (
token = 'ZRHzdgKEi6Wg0+gZ1dvMEpBJSh/d+NwnXMAaFoj5CJM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)