UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pHzlJ7PKFPoEriEHM9SbyBuBdHE0PCecyvwcl4xzWyA='
WHERE
key_id = 'df607eec38c62f10046804d710cb3df79706d06203dd81506041fe5dc1bf1a48'
AND (
token = 'pHzlJ7PKFPoEriEHM9SbyBuBdHE0PCecyvwcl4xzWyA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)