UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xpf8MI04L6KjaGk+3PmRGz3RGF+CdXz6RPNFyWKGX2w='
WHERE
key_id = 'bdc9d1426ca1a1bba2a408d50d736cb99955116d1f336a9b7a8cac38420d676a'
AND (
token = 'Xpf8MI04L6KjaGk+3PmRGz3RGF+CdXz6RPNFyWKGX2w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)