UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sZsVG+mK9rS4IRacJLZtrw9Bu9g8uoHL6P20fkbsUSk='
WHERE
key_id = 'bb85ec7b818ea21cd78810a5a72c573bf50e00b9609752b1149cca71f031bf07'
AND (
token = 'sZsVG+mK9rS4IRacJLZtrw9Bu9g8uoHL6P20fkbsUSk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)