UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k7RgVWQuuLarXiqfMVwW4ibqCSOoFDSI97rKa8aLGrs='
WHERE
key_id = '3550c1e4bd84b4ec877b7a4d62a63e9f13eab7aaf40d538217dd51cbbe08c451'
AND (
token = 'k7RgVWQuuLarXiqfMVwW4ibqCSOoFDSI97rKa8aLGrs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)