UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dZuHLf6sHs36ZcgSh2W6pCQhF4xxKkKNiZRT0WoQcHo='
WHERE
key_id = '0a6c45c1f77e9999a638c604151329ae646852171629c0d9abb0b0203efe84a1'
AND (
token = 'dZuHLf6sHs36ZcgSh2W6pCQhF4xxKkKNiZRT0WoQcHo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)