UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5BGACNCU+Eb7d6bEswzBwvO0+hx+f2z5/4t/+n4jKBQ='
WHERE
key_id = '2b78d5a3e1f4b21ef853d1f4485ad56e2ce18ff5339802ddcb89953445ea4ef5'
AND (
token = '5BGACNCU+Eb7d6bEswzBwvO0+hx+f2z5/4t/+n4jKBQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)