UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cBnIZ4tglKYIRg2Mi55eb6dAfEChinz3Sk40BZKez4A='
WHERE
key_id = '512d493592bb8cd3ca50763308463aaf3c9b13369b1deb93ae264c48b32c3e52'
AND (
token = 'cBnIZ4tglKYIRg2Mi55eb6dAfEChinz3Sk40BZKez4A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)