UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qR7PnXcOF15LOU8ECdiqJXBNg915cWtJra6gvroKJ1A='
WHERE
key_id = '9bf343d16e6527f10f81c7c425f5d4f4ad9fe67855d2446461006c68b1b34ccf'
AND (
token = 'qR7PnXcOF15LOU8ECdiqJXBNg915cWtJra6gvroKJ1A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)