UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gqXlGixWlZ0QOXa/Nb8NmqZ+V1vrcAN50OcI0xmTRIM='
WHERE
key_id = 'b9706e1fcad5b15d582a57825e453df26c8b3f0176228ab34414a13b2e461436'
AND (
token = 'gqXlGixWlZ0QOXa/Nb8NmqZ+V1vrcAN50OcI0xmTRIM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)