UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AdVvFkjW9oCL88fbcAjUIfXDW35Rxi3jTuP24y51EvA='
WHERE
key_id = '362b9753b58e9865f37cb3aae4cb4fce914404b219c42b86939ff3c118d341e8'
AND (
token = 'AdVvFkjW9oCL88fbcAjUIfXDW35Rxi3jTuP24y51EvA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)