UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'te9zxZWMyMTvTFyrXlfgn1m5r8S8PIozSc1Jho93D5M='
WHERE
key_id = '7d4033d107e4c18358d119f26dcb10e1c62eecef68ffb541e8ed904b356ab011'
AND (
token = 'te9zxZWMyMTvTFyrXlfgn1m5r8S8PIozSc1Jho93D5M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)