UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kKZ02xbbsZKAYkTbFqb8M3o8N//msCFq1GSSyg2hbcg='
WHERE
key_id = '1a6764df5c12b4ec7fe093fae477f526f032dd504eb7aa304aefb6263341f20b'
AND (
token = 'kKZ02xbbsZKAYkTbFqb8M3o8N//msCFq1GSSyg2hbcg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)