UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4C9aoaCoHL7q84mKv0T3zxvztbvCNvgN0RH42W1vyeU='
WHERE
key_id = '3ab96104097a8afb5cacb0c95bf70f620c10b5a03ff3bf5e903d8a8774305c9c'
AND (
token = '4C9aoaCoHL7q84mKv0T3zxvztbvCNvgN0RH42W1vyeU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)