UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+rYsKAXbjXGc7O9mD4skyHiBuInTarUOArDHTe0ZX4I='
WHERE
key_id = '3ae2024374f07bc62a6075e02c81112c3abe3b18d9a526a399d7cbed98de87e4'
AND (
token = '+rYsKAXbjXGc7O9mD4skyHiBuInTarUOArDHTe0ZX4I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)