UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CkQNxRpQ/r4OhoMM7eAZvE1/ydhWSaoyDbSayzEmbdg='
WHERE
key_id = 'ab9157628bf52a3c7aacc43a0e3e17602fcc2e6087a065ad36fe0141b67e2b6f'
AND (
token = 'CkQNxRpQ/r4OhoMM7eAZvE1/ydhWSaoyDbSayzEmbdg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)