UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZRyFwOAsZG9fnp09YfW8EerOq+h+svlulPFMJe1Sy10='
WHERE
key_id = '2b99a1cb9427e5104e4f95c319becd0fe0b5c9f5d98fa3fb3c4bd4547222bcc0'
AND (
token = 'ZRyFwOAsZG9fnp09YfW8EerOq+h+svlulPFMJe1Sy10='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)