UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KHrkVIq59hVm92Fkr2SoPR7slU5VeOB9k2WXewVtXuw='
WHERE
key_id = '3c12d2390282cca8f21d42c596ed6123bf026443b6b482192d6c7d017fdd1050'
AND (
token = 'KHrkVIq59hVm92Fkr2SoPR7slU5VeOB9k2WXewVtXuw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)