UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zTdKWzzUkbayzqohlXmq3eqcNEi8Y8dmTshl/IZoieA='
WHERE
key_id = '8200d653f14bb13b64ef8990f527d6e0e5028e68b326f6da7950b4fb90786176'
AND (
token = 'zTdKWzzUkbayzqohlXmq3eqcNEi8Y8dmTshl/IZoieA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)