UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mXhgZZESj27LUJ+OCzrHJ1oQdqlWQ5uW1EcO+AZ9ecc='
WHERE
key_id = '48dc146d14a5c4f413d03f54b390fc31155c1d7c5e4197ccd688f3175965b691'
AND (
token = 'mXhgZZESj27LUJ+OCzrHJ1oQdqlWQ5uW1EcO+AZ9ecc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)