UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5t8hGgeZsTpIsfF3eFq5Ueipae2tMX9SjGVwxz64qvM='
WHERE
key_id = 'e9217c83fa6caf32a9c67caf6b16779f567448f3043e7e03adc4e71b06b02b98'
AND (
token = '5t8hGgeZsTpIsfF3eFq5Ueipae2tMX9SjGVwxz64qvM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)