UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UKPJM/U3H8sdK2nzlJoOiaZp96MiMoThZ+0nrmgNJws='
WHERE
key_id = '1fa38299c2f6259771d1befcbf48043b5af59f949250becdc2ac48ae52564fe9'
AND (
token = 'UKPJM/U3H8sdK2nzlJoOiaZp96MiMoThZ+0nrmgNJws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)