UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gED7MIXzi/YdxtOW563HPrh8VMUTYaE5cTNramAUUA8='
WHERE
key_id = '74efc3679e89ff8a07be48264f96a8031cbf887a95a277df2f49dd30dad673fb'
AND (
token = 'gED7MIXzi/YdxtOW563HPrh8VMUTYaE5cTNramAUUA8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)