UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MrNY4WFICUT6KkQeWJRRHCXFXOIdBdp1pnMemg9AE60='
WHERE
key_id = '3f09c731956759b7ddfa8e1cbdb16c014c9161284f4aabed723717b7ffad192e'
AND (
token = 'MrNY4WFICUT6KkQeWJRRHCXFXOIdBdp1pnMemg9AE60='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)