UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XDNEDzW64vbvYY2aGOJ9EdTS0Km10QaFCNgYWbM5DXg='
WHERE
key_id = '06befbedc40c1d1659035658b2aefbdb4df4f4df3c3e599d3e5ab3225501bc41'
AND (
token = 'XDNEDzW64vbvYY2aGOJ9EdTS0Km10QaFCNgYWbM5DXg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)