UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EHjrIrNGjLMpJlFQN0RCsqA28jAMoFi4hS72PuKY61Y='
WHERE
key_id = 'c0edead83bde40641e2b4f4d8a9f3cb47bddbe9b0b95d360620b75d18a62d763'
AND (
token = 'EHjrIrNGjLMpJlFQN0RCsqA28jAMoFi4hS72PuKY61Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)