UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'brPiUH2il/n1ph7mHT6K+AS+gkuE37XfOJ2zD8nLdMM='
WHERE
key_id = 'f9ea9e9073b88e89dcf31d345cac1ca545d6116a113853c4f8c5f897b68ca33e'
AND (
token = 'brPiUH2il/n1ph7mHT6K+AS+gkuE37XfOJ2zD8nLdMM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)