UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9JekG+GixbDgeNj6djOXKh8egiFVyyDcqoOZSM2+2vo='
WHERE
key_id = 'b2d9690edc362ea44e5c125b0f4fe1872e97c78d72397e2e2b17e453954901b2'
AND (
token = '9JekG+GixbDgeNj6djOXKh8egiFVyyDcqoOZSM2+2vo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)